﻿This ARMER2018readme.txt file was generated on 20210602 by Lisa Jordan


-------------------
GENERAL INFORMATION
-------------------


Title of Dataset: Annual Firearms Manufacturing and Export Report, 2018




Original Data Available in .PDF format from the Bureau of Alcohol, Firearms and Tobacco (ATF), 
published January 28, 2020.  
saved as afmer_2018_web_report_final_508.pdf




Data Conversion Information:




        Completed by: Lisa Jordan, Drew University, 36 Madison Ave., Madison, NJ,                                           
                        ljordan@drew.edu
                      Marwa Elessawy, Drew University, 36 Madison Ave., Madison, NJ
                Graham Munro-Ludders, Drew University, 36 Madison Ave., Madison, NJ
                      Jason Jordan, Drew University, 36 Madison Ave., Madison, NJ




Date of data conversion: 20210601




Geographic location of data conversion: Drew University, Madison, New Jersey 07940, USA




Funding for this project came from the Drew University Digital Humanities Summer Institute (DHSI), funded by a grant from the Andrew W. Mellon Foundation.




--------------------------
SHARING/ACCESS INFORMATION
-------------------------- 


Licenses/restrictions placed on the data, or limitations of reuse: as is


Recommended citation for the data: 


ATF. 2020. "Annual Firearms Manufacturing and Export Report, 2018." Originally published by the Bureau of Alcohol, Firearms and Tobacco (ATF), 28 January 2020, Washington, DC. Downloaded 24 May 2021 from https://www.atf.gov/file/142946/download.  Data compiled and aggregated to .csv format by L. Jordan, M. Elessawy, G. Munro-Ludders, J. Jordan. 06 June. Available online from Harvard Dataverse.




--------------------
DATA & FILE OVERVIEW
--------------------


ARMER2018.csv: included all data from ATF, 2020, and two new columns (fields): mfgtotal, and exptotal.  Please note: data are listed by RDS KEY, a unique identifier by manufacturer location.  There are multiple instances for some companies (e.g. Sturm, Ruger & Company, Inc. is listed as producing in multiple locations, and contains different records or rows for each location).  


Data derived from: 
Department of Justice, Bureau of Alcohol, Tobacco, Firearms and Explosives, 2020. ANNUAL FIREARMS MANUFACTURING AND EXPORT REPORT 2018. Washington, DC.




--------------------------
METHODOLOGICAL INFORMATION
--------------------------




Description of methods used for collection/generation of data: 




AFMER2018.csv was created by 1) converting the ATF .PDF report was converted to an .xls file using Adobe software, 2) the aggregate spreadsheet was separated into several different worksheets based on gun type, 3) the data were cleaned and verified by data compilers and saved as separate .csv files (totals for each of the gun types match summary measures also reported by the Annual Firearms Manufacturing and Export Report), 4) separate .csv files were merged using stata based on the RDS KEY: a unique identifier used by the ATF in processing Federally Licensed Firearms Manufacturers, and 5)  new columns called mfgtotal and exptotal were created.  exptotal sums all export firearms listed by ATF.  mfgtotal sums all manufacturing totals listed by ATF.  


A detailed summary of AFMER data characteristics can be found here: 
Brauer, Jurgen. “Data Sources and Issues.” The US Firearms Industry. Small Arms Survey, 2013. https://www.jstor.org/stable/resrep10770.8.


Software: .csv files may be viewed in Microsoft Excel, Google Sheets, or in a text reader, such as notepad, or through a web browser. 




--------------------------
DATA-SPECIFIC INFORMATION
--------------------------




ARMER2019.csv




Number of variables: 29
Number of cases/rows: 2366 rows, including 1 header row


Variable list: most variable names were adopted from the original ATF document  




rdskey: ID number, unique to each license by location, not by company (company names may duplicate), RDS stands for Region, District, Sequence
license: name of federal firearms manufacturer licensee
street: location of manufacturer
city: city name
state: state US postal code


miscexp: number of miscellaneous firearms exported, 2018
pistolsexp: number of pistols exported, 2018
revolversexp: number of revolvers exported, 2018
rifleexp: number of rifles exported, 2018
shotgunexp: number of shotguns exported, 2018


For the following attribute definitions, this metadata adopts Brauer’s definition of AFMER numbers as “sales into commerce, i.e.g to wholesalers, retailers, or directly to end users, whether from current-year production or from prior-year inventories” (p. 17, The US Firearms Industry: Production and Supply)


misc: number of miscellaneous firearms sold into commerce by manufacturer, 2018




pistol22: number of 22 caliber pistols sold into commerce by manufacturer, 2018
pistol25: number of 25 caliber pistols sold into commerce by manufacturer, 2018
pistol32: number of 32 caliber pistols sold into commerce by manufacturer, 2018
pistol380: number of pistol 380s sold into commerce by manufacturer, 2018
pistol9mm: number of 9mm pistols sold into commerce by manufacturer, 2018
pistol50: number of 50 caliber pistols sold into commerce by manufacturer, 2018
pistoltotal: total number of pistols, all types, sold into commerce by manufacturer, 2018




rvlr22: number of 22 caliber revolvers sold into commerce by manufacturer, 2018
rvlr32: number of 32 caliber revolvers sold into commerce by manufacturer, 2018
rvlr357: number of 357 revolvers sold into commerce by manufacturer, 2018
rvlr38: number of 38 caliber revolvers sold into commerce by manufacturer, 2018
rvlr44: number of 44 caliber revolvers sold into commerce by manufacturer, 2018
rvlr50: number of 50 caliber revolvers sold into commerce by manufacturer, 2018
rvlrtotl: total number of revolvers sold into commerce by manufacturer, 2018


rifles: number of rifles sold into commerce by manufacturer, 2018


shotguns: number of shotguns sold into commerce by manufacturer, 2018


mfgtotal: the sum of misc, pistoltotal, rvlrtotl, rifles, shotguns
exptotal: the sum of miscexp, pistolsexp, revolversexp, rifleexp, and shotgunexp




Missing data codes: left blank, <NULL>


This metadata is based on the Cornell University readme template, available online: https://cornell.box.com/v/ReadmeTemplate [last downloaded 14 May 2019]